object dmUpdateFiles: TdmUpdateFiles
  OldCreateOrder = False
  Left = 375
  Top = 35
  Height = 344
  Width = 377
  object cdsGetUpdateFileList: TClientDataSet
    Aggregates = <>
    Params = <>
    Left = 187
    Top = 56
    object cdsGetUpdateFileListsubsys_code: TStringField
      FieldName = 'subsys_code'
      Size = 50
    end
    object cdsGetUpdateFileListnode_id: TSmallintField
      FieldName = 'node_id'
    end
    object cdsGetUpdateFileListpath: TStringField
      FieldName = 'path'
      Size = 50
    end
    object cdsGetUpdateFileListfilename: TStringField
      FieldName = 'filename'
      Size = 50
    end
    object cdsGetUpdateFileListforce_flag: TStringField
      FieldName = 'force_flag'
      FixedChar = True
      Size = 1
    end
    object cdsGetUpdateFileListfile_date: TDateTimeField
      FieldName = 'file_date'
    end
    object cdsGetUpdateFileListmemo: TStringField
      FieldName = 'memo'
      Size = 200
    end
    object cdsGetUpdateFileListupdate_flag: TStringField
      FieldKind = fkInternalCalc
      FieldName = 'update_flag'
      Size = 1
    end
    object cdsGetUpdateFileListusing_flag: TStringField
      FieldKind = fkInternalCalc
      FieldName = 'using_flag'
      Size = 1
    end
    object cdsGetUpdateFileListenable: TStringField
      FieldName = 'enable'
      FixedChar = True
      Size = 1
    end
  end
  object adqCreateSysUpdateAlert: TADOQuery
    Parameters = <>
    SQL.Strings = (
      
        'IF  not EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_I' +
        'D(N'#39'[sys_sys_update_alert]'#39') AND OBJECTPROPERTY(id, N'#39'IsUserTabl' +
        'e'#39') = 1)'
      'BEGIN'
      ''
      'CREATE TABLE [sys_sys_update_alert]('
      '[id] [int] IDENTITY(1,1) NOT NULL,'
      '[subsys] [varchar](50) NOT NULL,'
      '[enable] [bit] NOT NULL,'
      '[func] [varchar](100) NULL,'
      '[memo] [varchar](8000) NULL,'
      '[sort_sn] [smallint] NULL,'
      '[time] [datetime] NOT NULL,'
      ' CONSTRAINT [PK_sys_sys_update_alert] PRIMARY KEY CLUSTERED '
      '('
      '[id] ASC'
      ')WITH FILLFACTOR = 90 ON [PRIMARY]'
      ') ON [PRIMARY]'
      ''
      ''
      ''
      
        'CREATE NONCLUSTERED INDEX [IX_sys_sys_update_alert] ON [sys_sys_' +
        'update_alert] '
      '('
      '[subsys] ASC,'
      '[enable] ASC'
      ')WITH FILLFACTOR = 90 ON [PRIMARY]'
      ''
      ''
      
        'ALTER TABLE [sys_sys_update_alert] ADD  CONSTRAINT [DF__sys_sys_' +
        'up__time__2256BA89]  DEFAULT (getdate()) FOR [time]'
      'END')
    Left = 184
    Top = 168
  end
  object adqCreateSysUpdateAlertLog: TADOQuery
    Parameters = <>
    SQL.Strings = (
      
        'IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID' +
        '(N'#39'[sys_sys_update_alert_log]'#39') AND OBJECTPROPERTY(id, N'#39'IsUserT' +
        'able'#39') = 1)'
      'BEGIN'
      ''
      'CREATE TABLE [sys_sys_update_alert_log]('
      '[id] [int] NOT NULL,'
      '[subsys] [varchar](50) NOT NULL,'
      '[emp_sn] [varchar] (25) NOT NULL,'
      '[computer_ip] [varchar](100) NOT NULL,'
      '[computer_name] [varchar](100) NOT NULL,'
      '[log_time] [datetime] NULL,'
      ' CONSTRAINT [PK_sys_sys_update_alert_log] PRIMARY KEY CLUSTERED '
      '('
      #9'[id] ASC,'
      #9'[subsys] ASC,'
      #9'[emp_sn] ASC,'
      #9'[computer_ip] ASC,'
      #9'[computer_name] ASC'
      ')WITH FILLFACTOR = 90 ON [PRIMARY]'
      ') ON [PRIMARY]'
      ''
      ''
      ''
      
        'CREATE NONCLUSTERED INDEX [IX_sys_sys_update_alert_log] ON [sys_' +
        'sys_update_alert_log] '
      '('
      '[id] ASC,'
      '[subsys] ASC,'
      '[emp_sn] ASC,'
      '[computer_ip] ASC,'
      '[computer_name] ASC'
      ')WITH FILLFACTOR = 90 ON [PRIMARY]'
      ''
      ''
      
        'ALTER TABLE [sys_sys_update_alert_log] ADD  CONSTRAINT [DF__sys_' +
        'sys_up__log_time__2256BA89]  DEFAULT (getdate()) FOR [log_time]'
      'END')
    Left = 184
    Top = 216
  end
  object cdsTemp: TClientDataSet
    Aggregates = <>
    Params = <>
    Left = 56
    Top = 168
  end
end
